package org.madmac.pessoa;


import org.wakeful.conn.Connection;
import org.wakeful.query.Query;
/**
 *
 * @author atila camurca
 */
public final class PessoaQuery {

	public static final String TABLE = Connection.getSchema().concat(Query.DOT).concat("pessoa");
   public static final String ALIAS = TABLE.concat(" p");

	private PessoaQuery() {
	}
	
	public static String create() {
      StringBuilder builder = new StringBuilder();
      builder.append(Query.INSERT);
      builder.append(PessoaQuery.TABLE);
      builder.append(" (nome)");
      builder.append(Query.VALUES);
      builder.append("(UPPER(?))");
      builder.append(Query.RETURNING);
      builder.append("id_pessoa");
      return builder.toString();
   }
   
   public static String retrieve() {
      StringBuilder builder = new StringBuilder();
      builder.append("");
      return builder.toString();
   }
   
   public static String update() {
      StringBuilder builder = new StringBuilder();
      builder.append("");
      return builder.toString();
   }
   
   public static String delete() {
      StringBuilder builder = new StringBuilder();
      builder.append("");
      return builder.toString();
   }
}
